🕷️️ Job Radar • SCRAPING

freelancer.com 2026-04-26 🟢

🔹 Add reliable contact details for UK local election candidates
👤 Client: 🇬🇧 Leicester, United Kingdom Member since 2022-11-08
💰 Price: $152 Average bid
🚩 Problem: Gather personal or party emails, then social media handles if no email is found.
📦 Existing: Google Sheet with names, wards, and parties of 942 candidates.

Specifications:

[Target] Populate missing contact information in a Google Sheet for each candidate.
[Method] Use public records and quick AI look-ups (verify results).
[UI/UX] Not applicable.
[Stack] Python with libraries like BeautifulSoup, requests; Google Sheets API.
[Security] Ensure data privacy and handle sensitive information securely.
[Format] JSON structure for structured output.

Workflow:

1. Set up environment: Install necessary Python libraries (BeautifulSoup, requests), authenticate Google Sheets API.
2. Iterate through each candidate in the provided list, starting with their name and ward.
3. For each candidate, search for a personal email using public records and quick AI look-ups.
4. If no personal email is found, locate the most appropriate local party email.
5. If neither email can be found, proceed to social media: Instagram, Twitter, Facebook in that order.
6. Verify all entries by cross-referencing with public records and candidate profiles.
7. Update Google Sheet with verified contact information.